REGISTROSALIDAHQ

"192.168.0.1:sipop"

REGISTROSALIDAHQ

Descriptions

REGISTRO DE SALIDA DE BODEGA DE HERRAMIENTAS Y EQUIPOS

Fields

PK	FK	Name	Domain	Data type	Not null	Default	Description
		ID_REGISTRO_SALIDAD		CHAR (8)
		FECHA_SALIDA		DATE
		TIPO_DE_SALIDA		CHAR (2)
		AUTORIZADO_POR		CHAR (3)
		RECIBIDO_POR		CHAR (3)
		REQUISICION		CHAR (8)
		USER_DIGITADOR		VARCHAR (20)
		DATETIME_INSERT		TIMESTAMP
		DESCRIPCION		VARCHAR (160)

Triggers

Trigger	Type	Active	Position	Description
REGISTROSALIDAHQ_BI	Before Insert		0

Indices

There are no indices for table REGISTROSALIDAHQ

References

Table	Foreign Key	Fields	FK Fields	DEL Rule	UPD Rule
TIPOSALIDA	INTEG_263	TIPO_DE_SALIDA	ID_TIPO_SALIDA	RESTRICT	RESTRICT

Referenced

There are no tables referenced by table REGISTROSALIDAHQ

Definition


CREATE TABLE REGISTROSALIDAHQ (
    ID_REGISTRO_SALIDAD CHAR (8) CHARACTER SET NONE NOT NULL COLLATE NONE,
    FECHA_SALIDA DATE NOT NULL,
    TIPO_DE_SALIDA CHAR (2) CHARACTER SET NONE NOT NULL COLLATE NONE,
    AUTORIZADO_POR CHAR (3) CHARACTER SET NONE COLLATE NONE,
    RECIBIDO_POR CHAR (3) CHARACTER SET NONE NOT NULL COLLATE NONE,
    REQUISICION CHAR (8) CHARACTER SET NONE COLLATE NONE,
    USER_DIGITADOR VARCHAR (20) CHARACTER SET NONE COLLATE NONE,
    DATETIME_INSERT TIMESTAMP,
    DESCRIPCION VARCHAR (160) CHARACTER SET NONE COLLATE NONE);

ALTER TABLE REGISTROSALIDAHQ ADD PRIMARY KEY (ID_REGISTRO_SALIDAD);
ALTER TABLE REGISTROSALIDAHQ ADD  FOREIGN KEY (TIPO_DE_SALIDA) REFERENCES TIPOSALIDA (ID_TIPO_SALIDA);

This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m.